package dlwntk6545.swing.jdbc;

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;

public class J26_SungJukDAO {
	
	private String DRV = "oracle.jdbc.driver.OracleDriver";
	private String URL = "jdbc:oracle:thin:dlwntk6545/dlwntk6545@112.216.253.125:1521:xe";
	private String insertSQL = "insert into j26sungjuk values"
								+ "(exam.nextval, ?, ?, ?, ?, ?, ?, ?, sysdate)";
	
	protected Connection openDatabase(){
		
		try{
			Class.forName(DRV);
			return DriverManager.getConnection(URL);
		}catch(Exception ex){
			ex.printStackTrace();
		}
		return null;
	}
	
	protected void closeDatabase(Connection c, PreparedStatement p, ResultSet r){
		
		if(c != null)try{c.close(); c = null;}catch(Exception ex){}
		if(p != null)try{p.close(); p = null;}catch(Exception ex){}
		if(r != null)try{r.close(); r = null;}catch(Exception ex){}
		
	}
	
	public boolean insertSungJuk(J26_SungJukVO sj){
		
		boolean result = false;
		Connection conn = null;
		PreparedStatement pstmt = null;
		
		try{
			
			conn = this.openDatabase();
			pstmt = conn.prepareStatement(insertSQL);
			pstmt.setString(1, sj.getName());
			pstmt.setString(2, sj.getKor());
			pstmt.setString(3, sj.getEng());
			pstmt.setString(4, sj.getMat());
			pstmt.setString(5, sj.getTot());
			pstmt.setString(6, sj.getAvg());
			pstmt.setString(7, sj.getGrd());
			pstmt.executeUpdate();
			result = true;
			
		}catch (Exception ex) {
			
			ex.printStackTrace();
			
		}finally{
			
			this.closeDatabase(conn, pstmt, null);
			
		}
		
		return result;
		
	}
	
	
}
